<%-- 
    Document   : viewstatus
    Created on : Jun 11, 2012, 9:40:18 PM
    Author     : praneeth
--%>
<%@page import="java.sql.* " %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<title>ViewStatus</title>
</head>
<body>
<div id="container">
<div id="header">
       <h2>E Gas Sewa</span></h2>
<div id="footer"><h6>Copyright © MIPGS09-12 org</h6></div>  </div>   
    <div id="menu">
        	<ul>
            	<li class="menuitem"><a href="#">Home</a></li>
                <li class="menuitem"><a href="#">About</a></li>
                <li class="menuitem"><a href="#">Products</a></li>
                <li class="menuitem"><a href="#">Services</a></li>
               <li class="menuitem"><a href="#">Contact</a></li>
	  </ul>
    </div>
        <div id="leftmenu">
    	            <div id="leftmenu_top"></div>
	    		<div id="leftmenu_main">                  
                <h3></h3>                        
                <ul>
                    <li><a href="UpdateAcc.jsp">Update Account</a></li>
                    <li><a href="refill.jsp">Refill</a></li>
                    <li><a href="TransferCustomer.jsp">Transfer Account</a></li>
                    <li><a href="SearchDealer.jsp">Search Dealer</a></li>
                    <li><a href="Cancl.jsp">Cancellation</a></li>
                    <li><a href="NewConnection.jsp">NewConnection</a></li>
                    <li><a href="SearchAccessori.html">Accessories</a></li>
                    <li><a href="#">Notification</a></li>
                </ul>
</div>
<div id="leftmenu_bottom"></div></div>
	<div id="content">        
        <div id="content_top"></div>
        <div id="content_main">	  
    <form>    
     <table border="1" width="90%" cellpadding="4">
     <tr>
           <th><font color="blue">Refill_id</th>
           <th><font color="blue">Bookindate</th>
           <th><font color="blue">deliveryDate</th>
           <th><font color="blue">Status</th>
     </tr>
        <tr>
            
          <% 
       try{     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            
            
      String q1="select * from Status";
             
       
        Connection connection = DriverManager.getConnection("jdbc:odbc:egasdsn");
        Statement stmt =connection.createStatement();
        
        
       
        ResultSet rs =stmt.executeQuery(q1);
            while(rs.next()){
                String userid=rs.getString(1);
                String pwd=rs.getString(2);
                String hq=rs.getString(3);
                String ha=rs.getString(4);
                %>
                
                <tr>   <td><font color="blue"><%=  userid%> </td>
            <td><font color="blue"><%= pwd %></td>
            <td><font color="blue"><%= hq %></td>
            <td><font color="blue"><%= ha %></td></tr>
    <%               
            }
               
        }catch(Exception e){
        }

    %>
            </tr>
    </table></form>
			
	</div>
        <div id="content_bottom"></div> 
                        
      </div>
   </div>
</body>
</html>
